﻿ALTER PROCEDURE [dbo].[sp_Thanh_GetSellingRateList_2] 
	@idHBL int
AS
BEGIN
	select f.FeeName, s.UnitPrice, s.Quantity, s.Price,c.ID_Currency, s.Description, s.ID_SellingFee
	from tblFee as f, tblCurrency as c, tblSellingFee as s
	where f.ID_Fee = s.ID_Fee and s.ID_HBL = @idHBL and c.ID_Currency = s.ID_Currency and s.UnitPrice <>0
	order by f.[Rank]
END